DateTimeString is a string including a Date and a Time value.
Evaluates the string specified and converts the Time value to the number of seconds from 00:00:00 (12:00 midnight) to the specified time.
The following example is applicable to Crystal syntax:
DTSToSeconds("2000/01/13 11:30:15")
Instead of using the DTSToSeconds function, you can use:
DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (DateTimeString)))
The above expression is able to convert more types of strings.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |